CREATE TABLE [dbo].[FS_Delay]
(
[fdLatID] [int] NOT NULL IDENTITY(1, 1),
[fdLatSelf] [bit] NOT NULL CONSTRAINT [DF_FS_Delay_fdLatSelf] DEFAULT ((1)),
[fdLatColl] [bit] NOT NULL CONSTRAINT [DF_FS_Delay_fdLatColl] DEFAULT ((0)),
[fdLatAdmin] [bit] NOT NULL CONSTRAINT [DF_FS_Delay_fdLatAdmin] DEFAULT ((0)),
[fdLatType] [int] NOT NULL CONSTRAINT [DF_FS_Delay_fdLatType] DEFAULT ((1)),
[fdLatNote] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStuNo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStuName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStuSpec] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStuLong] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStuPlace] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdConHomeTel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdConFriTel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdConTel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdConEmail] [varchar] (150) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdConHomeAdd] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdConPostAdd] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdDelayOtherStu] [int] NOT NULL CONSTRAINT [DF_FS_Delay_fdDelayOtherStu] DEFAULT ((0)),
[fdDelayUnitName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Delay_fdDelayUnitName] DEFAULT (''),
[fdDelayUnitContrator] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Delay_fdDelayUnitContrator] DEFAULT (''),
[fdDelayUnitTel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Delay_fdDelayUnitTel] DEFAULT (''),
[fdDelayUnitTime] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Delay_fdDelayUnitTime] DEFAULT (''),
[fdDelayReason] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Delay_fdDelayReason] DEFAULT (''),
[fdSelfStep] [int] NOT NULL CONSTRAINT [DF_FS_Delay_fdSelfStep] DEFAULT ((1)),
[fdSelfStepInfo] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Delay_fdSelfStepInfo] DEFAULT (''),
[fdSelfConsAdd] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Delay_fdSelfConsAdd] DEFAULT (''),
[fdSelfArchAdd] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Delay_fdSelfArchAdd] DEFAULT (''),
[fdOutArchAdd] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Delay_fdOutArchAdd] DEFAULT (''),
[fdOutStep] [int] NOT NULL CONSTRAINT [DF_FS_Delay_fdOutStep] DEFAULT ((1)),
[fdOutStepInfo] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Delay_fdOutStepInfo] DEFAULT (''),
[fdBackUnitName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Delay_fdUnitName] DEFAULT (''),
[fdBackUnitContacter] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Delay_fdBackUnitContacter] DEFAULT (''),
[fdBackUnitTel] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Delay_fdBackUnitTel] DEFAULT (''),
[fdBackStep] [int] NOT NULL CONSTRAINT [DF_FS_Delay_fdBackStep] DEFAULT ((1)),
[fdBackStepInfo] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Delay_fdBackStepInfo] DEFAULT (''),
[fdUpStep] [int] NOT NULL CONSTRAINT [DF_FS_Delay_fdUpStep] DEFAULT ((1)),
[fdUpUnitName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Delay_fdUpUnitName] DEFAULT ('')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FS_Delay] ADD CONSTRAINT [PK_FS_Delay] PRIMARY KEY CLUSTERED  ([fdStuNo]) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'MS_Description', N'是否民族生、结业生、定向生、委培生', 'SCHEMA', N'dbo', 'TABLE', N'FS_Delay', 'COLUMN', N'fdDelayOtherStu'
GO
EXEC sp_addextendedproperty N'MS_Description', N'1 暂缓 2 自谋 3 回家 4 国内升学  5出国', 'SCHEMA', N'dbo', 'TABLE', N'FS_Delay', 'COLUMN', N'fdLatType'
GO
EXEC sp_addextendedproperty N'MS_Description', N'1', 'SCHEMA', N'dbo', 'TABLE', N'FS_Delay', 'COLUMN', N'fdOutStep'
GO
